﻿CREATE TABLE [dbo].[BookingServiceSeatCLassDetail] (
    [BookingId]   INT NOT NULL,
    [SeatClassId] INT NOT NULL,
    [Amount]      INT NOT NULL,
    CONSTRAINT [PK_CTGiuChoHangGhe] PRIMARY KEY CLUSTERED ([BookingId] ASC, [SeatClassId] ASC),
    CONSTRAINT [FK_BookingServiceSeatCLassDetail_BookingService] FOREIGN KEY ([BookingId]) REFERENCES [dbo].[BookingService] ([Id]),
    CONSTRAINT [FK_BookingServiceSeatCLassDetail_SeatClass] FOREIGN KEY ([SeatClassId]) REFERENCES [dbo].[SeatClass] ([Id])
);

